Pandas Profiling Report

Dataset statistics

Number of variables	25
Number of observations	16554
Missing cells	26047
Missing cells (%)	6.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.6 MiB
Average record size in memory	164.0 B

Variable types

Numeric	16
Categorical	9

Alerts

`grade` is highly correlated with `bathrooms` and 5 other fields	High correlation
`sqft_basement` is highly correlated with `bedrooms` and 4 other fields	High correlation
`bathrooms` is highly correlated with `grade` and 4 other fields	High correlation
`bedrooms` is highly correlated with `grade` and 4 other fields	High correlation
`sqft_above` is highly correlated with `grade` and 9 other fields	High correlation
`sqft_living15` is highly correlated with `grade` and 4 other fields	High correlation
`floors` is highly correlated with `sqft_above` and 2 other fields	High correlation
`yr_renovated` is highly correlated with `jhygtf`	High correlation
`yr_built` is highly correlated with `zipcode` and 6 other fields	High correlation
`jhygtf` is highly correlated with `fue_renovada`	High correlation
`sqft_lot` is highly correlated with `sqft_lot15`	High correlation
`price` is highly correlated with `grade` and 3 other fields	High correlation
`sqft_lot15` is highly correlated with `zipcode` and 3 other fields	High correlation
`sqft_living` is highly correlated with `grade` and 6 other fields	High correlation
`fue_renovada` is highly correlated with `jhygtf`	High correlation
`antiguedad_venta` is highly correlated with `zipcode` and 6 other fields	High correlation
`view` is highly correlated with `waterfront`	High correlation
`waterfront` is highly correlated with `view`	High correlation
`zipcode` is highly correlated with `yr_built` and 2 other fields	High correlation
`condition` is highly correlated with `yr_built` and 1 other fields	High correlation
`sqft_basement` has 10142 (61.3%) missing values	Missing
`yr_renovated` has 15905 (96.1%) missing values	Missing
`df_index` has unique values	Unique
`jhygtf` has 15905 (96.1%) zeros	Zeros
`antiguedad_venta` has 320 (1.9%) zeros	Zeros

Reproduction

Analysis started	2022-10-04 04:35:39.353949
Analysis finished	2022-10-04 04:36:33.134697
Duration	53.78 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	16554
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18811.53262

Minimum	1
Maximum	113866
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1130.65
Q1	6188.5
median	14556.5
Q3	27262.5
95-th percentile	51274.25
Maximum	113866
Range	113865
Interquartile range (IQR)	21074

Descriptive statistics

Standard deviation	16147.10472
Coefficient of variation (CV)	0.8583619978
Kurtosis	1.628791243
Mean	18811.53262
Median Absolute Deviation (MAD)	9673.5
Skewness	1.265459165
Sum	311406111
Variance	260728990.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19857	1	< 0.1%
41861	1	< 0.1%
27591	1	< 0.1%
24402	1	< 0.1%
5679	1	< 0.1%
51523	1	< 0.1%
23241	1	< 0.1%
6184	1	< 0.1%
22233	1	< 0.1%
6765	1	< 0.1%
Other values (16544)	16544	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
5	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
12	1	< 0.1%
14	1	< 0.1%
15	1	< 0.1%

Value	Count	Frequency (%)
113866	1	< 0.1%
111906	1	< 0.1%
109571	1	< 0.1%
108311	1	< 0.1%
99297	1	< 0.1%
98195	1	< 0.1%
98015	1	< 0.1%
94768	1	< 0.1%
94083	1	< 0.1%
93739	1	< 0.1%

zipcode
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	70
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98079.01027

Minimum	98001
Maximum	98199
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	64.8 KiB

Quantile statistics

Minimum	98001
5-th percentile	98004
Q1	98033
median	98070
Q3	98118
95-th percentile	98177
Maximum	98199
Range	198
Interquartile range (IQR)	85

Descriptive statistics

Standard deviation	53.58031141
Coefficient of variation (CV)	0.0005462974317
Kurtosis	-0.88492992
Mean	98079.01027
Median Absolute Deviation (MAD)	43
Skewness	0.3725473414
Sum	1623599936
Variance	2870.849771
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98103	477	2.9%
98115	476	2.9%
98052	467	2.8%
98034	446	2.7%
98117	442	2.7%
98038	431	2.6%
98042	431	2.6%
98118	406	2.5%
98133	402	2.4%
98023	399	2.4%
Other values (60)	12177	73.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
98001	291	1.8%
98002	160	1.0%
98003	213	1.3%
98004	205	1.2%
98005	132	0.8%
98006	377	2.3%
98007	113	0.7%
98008	226	1.4%
98010	69	0.4%
98011	150	0.9%

Value	Count	Frequency (%)
98199	234	1.4%
98198	220	1.3%
98188	108	0.7%
98178	211	1.3%
98177	192	1.2%
98168	218	1.3%
98166	200	1.2%
98155	372	2.2%
98148	51	0.3%
98146	228	1.4%

grade
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.583967621

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	64.8 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	7
median	7
Q3	8
95-th percentile	10
Maximum	13
Range	12
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.103965081
Coefficient of variation (CV)	0.1455656374
Kurtosis	1.371933156
Mean	7.583967621
Median Absolute Deviation (MAD)	1
Skewness	0.7165229669
Sum	125545
Variance	1.2187389
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	7145	43.2%
8	4770	28.8%
9	1881	11.4%
6	1592	9.6%
10	698	4.2%
11	211	1.3%
5	183	1.1%
12	40	0.2%
4	23	0.1%
13	7	< 0.1%
Other values (2)	4	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
3	3	< 0.1%
4	23	0.1%
5	183	1.1%
6	1592	9.6%
7	7145	43.2%
8	4770	28.8%
9	1881	11.4%
10	698	4.2%
11	211	1.3%

Value	Count	Frequency (%)
13	7	< 0.1%
12	40	0.2%
11	211	1.3%
10	698	4.2%
9	1881	11.4%
8	4770	28.8%
7	7145	43.2%
6	1592	9.6%
5	183	1.1%
4	23	0.1%

sqft_basement
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	265
Distinct (%)	4.1%
Missing	10142
Missing (%)	61.3%
Infinite	0
Infinite (%)	0.0%
Mean	723.6218029

Minimum	10
Maximum	3500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.5 KiB

Quantile statistics

Minimum	10
5-th percentile	180
Q1	440
median	700
Q3	950
95-th percentile	1400
Maximum	3500
Range	3490
Interquartile range (IQR)	510

Descriptive statistics

Standard deviation	386.7235438
Coefficient of variation (CV)	0.5344277111
Kurtosis	2.023896471
Mean	723.6218029
Median Absolute Deviation (MAD)	260
Skewness	0.9228317222
Sum	4639863
Variance	149555.0993
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
600	179	1.1%
500	173	1.0%
700	166	1.0%
800	157	0.9%
400	138	0.8%
900	110	0.7%
1000	108	0.7%
300	106	0.6%
480	89	0.5%
530	86	0.5%
Other values (255)	5100	30.8%
(Missing)	10142	61.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	2	< 0.1%
20	1	< 0.1%
40	4	< 0.1%
50	7	< 0.1%
60	10	0.1%
65	1	< 0.1%
70	5	< 0.1%
80	14	0.1%
90	17	0.1%
100	30	0.2%

Value	Count	Frequency (%)
3500	1	< 0.1%
3480	1	< 0.1%
3260	1	< 0.1%
3000	1	< 0.1%
2730	1	< 0.1%
2600	1	< 0.1%
2550	1	< 0.1%
2500	1	< 0.1%
2400	1	< 0.1%
2390	1	< 0.1%

view
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	937.8 KiB

0	15123
2	666
3	324
1	251
4	190

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	16554
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	15123	91.4%
2	666	4.0%
3	324	2.0%
1	251	1.5%
4	190	1.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	15123	91.4%
2	666	4.0%
3	324	2.0%
1	251	1.5%
4	190	1.1%

Most occurring characters

Value	Count	Frequency (%)
0	15123	91.4%
2	666	4.0%
3	324	2.0%
1	251	1.5%
4	190	1.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16554	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	15123	91.4%
2	666	4.0%
3	324	2.0%
1	251	1.5%
4	190	1.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	16554	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	15123	91.4%
2	666	4.0%
3	324	2.0%
1	251	1.5%
4	190	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16554	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	15123	91.4%
2	666	4.0%
3	324	2.0%
1	251	1.5%
4	190	1.1%

bathrooms
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	970.1 KiB

2.0	8224
1.0	6635
3.0	1504
4.0	191

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	49662
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2.0
2nd row	1.0
3rd row	2.0
4th row	1.0
5th row	2.0

Common Values

Value	Count	Frequency (%)
2.0	8224	49.7%
1.0	6635	40.1%
3.0	1504	9.1%
4.0	191	1.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
2.0	8224	49.7%
1.0	6635	40.1%
3.0	1504	9.1%
4.0	191	1.2%

Most occurring characters

Value	Count	Frequency (%)
.	16554	33.3%
0	16554	33.3%
2	8224	16.6%
1	6635	13.4%
3	1504	3.0%
4	191	0.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	33108	66.7%
Other Punctuation	16554	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16554	50.0%
2	8224	24.8%
1	6635	20.0%
3	1504	4.5%
4	191	0.6%

Other Punctuation

Value	Count	Frequency (%)
.	16554	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	49662	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	16554	33.3%
0	16554	33.3%
2	8224	16.6%
1	6635	13.4%
3	1504	3.0%
4	191	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49662	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	16554	33.3%
0	16554	33.3%
2	8224	16.6%
1	6635	13.4%
3	1504	3.0%
4	191	0.4%

bedrooms
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	970.1 KiB

3.0	7846
4.0	5208
2.0	2163
5.0	1176
1.0	161

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	49662
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3.0
2nd row	3.0
3rd row	4.0
4th row	5.0
5th row	3.0

Common Values

Value	Count	Frequency (%)
3.0	7846	47.4%
4.0	5208	31.5%
2.0	2163	13.1%
5.0	1176	7.1%
1.0	161	1.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
3.0	7846	47.4%
4.0	5208	31.5%
2.0	2163	13.1%
5.0	1176	7.1%
1.0	161	1.0%

Most occurring characters

Value	Count	Frequency (%)
.	16554	33.3%
0	16554	33.3%
3	7846	15.8%
4	5208	10.5%
2	2163	4.4%
5	1176	2.4%
1	161	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	33108	66.7%
Other Punctuation	16554	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16554	50.0%
3	7846	23.7%
4	5208	15.7%
2	2163	6.5%
5	1176	3.6%
1	161	0.5%

Other Punctuation

Value	Count	Frequency (%)
.	16554	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	49662	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	16554	33.3%
0	16554	33.3%
3	7846	15.8%
4	5208	10.5%
2	2163	4.4%
5	1176	2.4%
1	161	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49662	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	16554	33.3%
0	16554	33.3%
3	7846	15.8%
4	5208	10.5%
2	2163	4.4%
5	1176	2.4%
1	161	0.3%

sqft_above
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	790
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1736.308626

Minimum	290
Maximum	8570
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.5 KiB

Quantile statistics

Minimum	290
5-th percentile	840
Q1	1180
median	1530
Q3	2140
95-th percentile	3230
Maximum	8570
Range	8280
Interquartile range (IQR)	960

Descriptive statistics

Standard deviation	770.3646816
Coefficient of variation (CV)	0.4436795797
Kurtosis	2.58879067
Mean	1736.308626
Median Absolute Deviation (MAD)	430
Skewness	1.316284753
Sum	28742853
Variance	593461.7427
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1200	167	1.0%
1300	157	0.9%
1010	155	0.9%
1400	153	0.9%
1220	146	0.9%
1340	146	0.9%
1180	145	0.9%
1060	145	0.9%
1140	140	0.8%
1100	134	0.8%
Other values (780)	15066	91.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
290	1	< 0.1%
380	1	< 0.1%
390	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
470	2	< 0.1%
480	4	< 0.1%
490	2	< 0.1%
500	2	< 0.1%

Value	Count	Frequency (%)
8570	1	< 0.1%
8020	1	< 0.1%
7680	1	< 0.1%
6420	1	< 0.1%
6380	1	< 0.1%
6350	1	< 0.1%
6200	1	< 0.1%
6110	1	< 0.1%
6090	1	< 0.1%
6070	1	< 0.1%

sqft_living15
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	679
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1944.15084

Minimum	460
Maximum	5790
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.5 KiB

Quantile statistics

Minimum	460
5-th percentile	1130
Q1	1470
median	1810
Q3	2300
95-th percentile	3190
Maximum	5790
Range	5330
Interquartile range (IQR)	830

Descriptive statistics

Standard deviation	649.2374266
Coefficient of variation (CV)	0.3339439581
Kurtosis	1.455088632
Mean	1944.15084
Median Absolute Deviation (MAD)	390
Skewness	1.059620425
Sum	32183473
Variance	421509.2361
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1440	160	1.0%
1560	159	1.0%
1540	155	0.9%
1500	150	0.9%
1460	144	0.9%
1720	138	0.8%
1580	137	0.8%
1480	134	0.8%
1610	134	0.8%
1520	134	0.8%
Other values (669)	15109	91.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
460	1	< 0.1%
620	2	< 0.1%
670	1	< 0.1%
690	2	< 0.1%
700	2	< 0.1%
710	1	< 0.1%
720	2	< 0.1%
740	5	< 0.1%
750	1	< 0.1%
760	2	< 0.1%

Value	Count	Frequency (%)
5790	5	< 0.1%
5600	1	< 0.1%
5380	1	< 0.1%
5330	1	< 0.1%
5220	1	< 0.1%
5080	1	< 0.1%
5070	1	< 0.1%
4950	1	< 0.1%
4930	1	< 0.1%
4913	1	< 0.1%

lat
Real number (ℝ_≥0)

Distinct	429
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4478.747493

Minimum	47
Maximum	47777
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	64.8 KiB

Quantile statistics

Minimum	47
5-th percentile	47
Q1	47
median	47
Q3	47
95-th percentile	47559
Maximum	47777
Range	47730
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	13818.36921
Coefficient of variation (CV)	3.085319999
Kurtosis	5.826857873
Mean	4478.747493
Median Absolute Deviation (MAD)	0
Skewness	2.797507278
Sum	74141186
Variance	190947327.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47	15010	90.7%
47686	13	0.1%
47695	12	0.1%
47543	12	0.1%
47567	11	0.1%
47554	11	0.1%
47679	11	0.1%
47637	10	0.1%
47687	10	0.1%
47697	10	0.1%
Other values (419)	1444	8.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
47	15010	90.7%
47184	1	< 0.1%
47194	1	< 0.1%
47196	2	< 0.1%
47201	1	< 0.1%
47202	1	< 0.1%
47205	1	< 0.1%
47208	1	< 0.1%
47209	2	< 0.1%
47258	2	< 0.1%

Value	Count	Frequency (%)
47777	2	< 0.1%
47776	7	< 0.1%
47775	3	< 0.1%
47774	9	0.1%
47773	5	< 0.1%
47772	3	< 0.1%
47771	3	< 0.1%
47769	1	< 0.1%
47768	5	< 0.1%
47767	2	< 0.1%

waterfront
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	937.8 KiB

0	16459
1	95

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	16554
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	16459	99.4%
1	95	0.6%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	16459	99.4%
1	95	0.6%

Most occurring characters

Value	Count	Frequency (%)
0	16459	99.4%
1	95	0.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16554	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16459	99.4%
1	95	0.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	16554	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	16459	99.4%
1	95	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16554	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	16459	99.4%
1	95	0.6%

floors
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	970.1 KiB

1.0	9811
2.0	6254
3.0	489

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	49662
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2.0
2nd row	1.0
3rd row	2.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	9811	59.3%
2.0	6254	37.8%
3.0	489	3.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
1.0	9811	59.3%
2.0	6254	37.8%
3.0	489	3.0%

Most occurring characters

Value	Count	Frequency (%)
.	16554	33.3%
0	16554	33.3%
1	9811	19.8%
2	6254	12.6%
3	489	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	33108	66.7%
Other Punctuation	16554	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16554	50.0%
1	9811	29.6%
2	6254	18.9%
3	489	1.5%

Other Punctuation

Value	Count	Frequency (%)
.	16554	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	49662	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	16554	33.3%
0	16554	33.3%
1	9811	19.8%
2	6254	12.6%
3	489	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49662	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	16554	33.3%
0	16554	33.3%
1	9811	19.8%
2	6254	12.6%
3	489	1.0%

yr_renovated
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	69
Distinct (%)	10.6%
Missing	15905
Missing (%)	96.1%
Infinite	0
Infinite (%)	0.0%
Mean	1995.50077

Minimum	1934
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.5 KiB

Quantile statistics

Minimum	1934
5-th percentile	1962
Q1	1986
median	2000
Q3	2008
95-th percentile	2014
Maximum	2015
Range	81
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	16.39624362
Coefficient of variation (CV)	0.00821660601
Kurtosis	0.7796489903
Mean	1995.50077
Median Absolute Deviation (MAD)	11
Skewness	-1.037317534
Sum	1295080
Variance	268.836805
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2014	73	0.4%
2013	30	0.2%
2005	24	0.1%
2000	24	0.1%
2007	23	0.1%
1990	20	0.1%
2006	20	0.1%
2003	19	0.1%
2004	17	0.1%
2009	16	0.1%
Other values (59)	383	2.3%
(Missing)	15905	96.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1934	1	< 0.1%
1940	2	< 0.1%
1944	1	< 0.1%
1945	2	< 0.1%
1946	2	< 0.1%
1948	1	< 0.1%
1950	2	< 0.1%
1951	1	< 0.1%
1953	3	< 0.1%
1954	2	< 0.1%

Value	Count	Frequency (%)
2015	11	0.1%
2014	73	0.4%
2013	30	0.2%
2012	9	0.1%
2011	8	< 0.1%
2010	11	0.1%
2009	16	0.1%
2008	15	0.1%
2007	23	0.1%
2006	20	0.1%

yr_built
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	116
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1970.676272

Minimum	1900
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.5 KiB

Quantile statistics

Minimum	1900
5-th percentile	1915
Q1	1951
median	1974
Q3	1996
95-th percentile	2011
Maximum	2015
Range	115
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	29.34426029
Coefficient of variation (CV)	0.01489045193
Kurtosis	-0.6692721324
Mean	1970.676272
Median Absolute Deviation (MAD)	23
Skewness	-0.4487016301
Sum	32622575
Variance	861.0856122
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2014	423	2.6%
2005	355	2.1%
2006	334	2.0%
2004	332	2.0%
2003	326	2.0%
1977	320	1.9%
2007	316	1.9%
1978	310	1.9%
1968	294	1.8%
2008	277	1.7%
Other values (106)	13267	80.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1900	61	0.4%
1901	24	0.1%
1902	23	0.1%
1903	36	0.2%
1904	36	0.2%
1905	52	0.3%
1906	68	0.4%
1907	59	0.4%
1908	66	0.4%
1909	64	0.4%

Value	Count	Frequency (%)
2015	30	0.2%
2014	423	2.6%
2013	152	0.9%
2012	126	0.8%
2011	102	0.6%
2010	113	0.7%
2009	178	1.1%
2008	277	1.7%
2007	316	1.9%
2006	334	2.0%

long
Real number (ℝ)

Distinct	608
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-109686.7868

Minimum	-122512
Maximum	-121
Zeros	0
Zeros (%)	0.0%
Negative	16554
Negative (%)	100.0%
Memory size	64.8 KiB

Quantile statistics

Minimum	-122512
5-th percentile	-122385
Q1	-122321
median	-122207
Q3	-122073
95-th percentile	-122
Maximum	-121
Range	122391
Interquartile range (IQR)	248

Descriptive statistics

Standard deviation	37055.04635
Coefficient of variation (CV)	-0.3378259809
Kurtosis	4.859395346
Mean	-109686.7868
Median Absolute Deviation (MAD)	118
Skewness	2.618907141
Sum	-1815755069
Variance	1373076460
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-122	1611	9.7%
-121	88	0.5%
-122362	81	0.5%
-122363	79	0.5%
-122291	77	0.5%
-122304	77	0.5%
-122351	76	0.5%
-122357	76	0.5%
-122352	75	0.5%
-122365	75	0.5%
Other values (598)	14239	86.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-122512	1	< 0.1%
-122503	1	< 0.1%
-122502	1	< 0.1%
-122497	1	< 0.1%
-122479	1	< 0.1%
-122475	1	< 0.1%
-122474	1	< 0.1%
-122472	1	< 0.1%
-122467	1	< 0.1%
-122465	2	< 0.1%

Value	Count	Frequency (%)
-121	88	0.5%
-122	1611	9.7%
-121315	2	< 0.1%
-121316	1	< 0.1%
-121319	1	< 0.1%
-121321	1	< 0.1%
-121325	1	< 0.1%
-121352	2	< 0.1%
-121359	1	< 0.1%
-121364	2	< 0.1%

jhygtf
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	70
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.23365954

Minimum	0
Maximum	2015
Zeros	15905
Zeros (%)	96.1%
Negative	0
Negative (%)	0.0%
Memory size	129.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	2015
Range	2015
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	387.3169349
Coefficient of variation (CV)	4.950771026
Kurtosis	20.56126148
Mean	78.23365954
Median Absolute Deviation (MAD)	0
Skewness	4.749415374
Sum	1295080
Variance	150014.408
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	15905	96.1%
2014	73	0.4%
2013	30	0.2%
2005	24	0.1%
2000	24	0.1%
2007	23	0.1%
1990	20	0.1%
2006	20	0.1%
2003	19	0.1%
2004	17	0.1%
Other values (60)	399	2.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	15905	96.1%
1934	1	< 0.1%
1940	2	< 0.1%
1944	1	< 0.1%
1945	2	< 0.1%
1946	2	< 0.1%
1948	1	< 0.1%
1950	2	< 0.1%
1951	1	< 0.1%
1953	3	< 0.1%

Value	Count	Frequency (%)
2015	11	0.1%
2014	73	0.4%
2013	30	0.2%
2012	9	0.1%
2011	8	< 0.1%
2010	11	0.1%
2009	16	0.1%
2008	15	0.1%
2007	23	0.1%
2006	20	0.1%

sqft_lot
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	7871
Distinct (%)	47.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9934.879667

Minimum	520
Maximum	137214
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.5 KiB

Quantile statistics

Minimum	520
5-th percentile	1715.65
Q1	5000
median	7480
Q3	10140
95-th percentile	29944
Maximum	137214
Range	136694
Interquartile range (IQR)	5140

Descriptive statistics

Standard deviation	10957.36316
Coefficient of variation (CV)	1.102918559
Kurtosis	31.24093454
Mean	9934.879667
Median Absolute Deviation (MAD)	2507.5
Skewness	4.698176897
Sum	164461998
Variance	120063807.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	289	1.7%
6000	221	1.3%
4000	197	1.2%
7200	174	1.1%
4800	97	0.6%
7500	95	0.6%
4500	93	0.6%
9600	91	0.5%
8400	88	0.5%
3600	79	0.5%
Other values (7861)	15130	91.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
520	1	< 0.1%
600	1	< 0.1%
609	1	< 0.1%
635	1	< 0.1%
638	1	< 0.1%
649	2	< 0.1%
651	1	< 0.1%
676	1	< 0.1%
681	1	< 0.1%
683	1	< 0.1%

Value	Count	Frequency (%)
137214	1	< 0.1%
136915	1	< 0.1%
136778	1	< 0.1%
136290	1	< 0.1%
130680	1	< 0.1%
130017	1	< 0.1%
127631	1	< 0.1%
125452	1	< 0.1%
122038	1	< 0.1%
120661	1	< 0.1%

price
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	3237
Distinct (%)	19.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	510603.4272

Minimum	75000
Maximum	7700000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.5 KiB

Quantile statistics

Minimum	75000
5-th percentile	210000
Q1	316000
median	440000
Q3	620000
95-th percentile	963000
Maximum	7700000
Range	7625000
Interquartile range (IQR)	304000

Descriptive statistics

Standard deviation	323805.8088
Coefficient of variation (CV)	0.634163015
Kurtosis	50.59509917
Mean	510603.4272
Median Absolute Deviation (MAD)	141000
Skewness	4.658301218
Sum	8452529134
Variance	1.048502018 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
350000	137	0.8%
450000	133	0.8%
425000	128	0.8%
550000	126	0.8%
500000	123	0.7%
375000	116	0.7%
325000	114	0.7%
300000	109	0.7%
400000	108	0.7%
250000	105	0.6%
Other values (3227)	15355	92.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
75000	1	< 0.1%
78000	1	< 0.1%
80000	1	< 0.1%
81000	1	< 0.1%
82000	1	< 0.1%
82500	1	< 0.1%
83000	1	< 0.1%
84000	1	< 0.1%
85000	2	< 0.1%
89000	1	< 0.1%

Value	Count	Frequency (%)
7700000	1	< 0.1%
7062500	1	< 0.1%
5570000	1	< 0.1%
5300000	1	< 0.1%
5110800	1	< 0.1%
4500000	1	< 0.1%
4000000	1	< 0.1%
3850000	1	< 0.1%
3800000	2	< 0.1%
3710000	1	< 0.1%

condition
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	937.8 KiB

3	10763
4	4357
5	1285
2	126
1	23

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	16554
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	3
3rd row	3
4th row	3
5th row	3

Common Values

Value	Count	Frequency (%)
3	10763	65.0%
4	4357	26.3%
5	1285	7.8%
2	126	0.8%
1	23	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
3	10763	65.0%
4	4357	26.3%
5	1285	7.8%
2	126	0.8%
1	23	0.1%

Most occurring characters

Value	Count	Frequency (%)
3	10763	65.0%
4	4357	26.3%
5	1285	7.8%
2	126	0.8%
1	23	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16554	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	10763	65.0%
4	4357	26.3%
5	1285	7.8%
2	126	0.8%
1	23	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	16554	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
3	10763	65.0%
4	4357	26.3%
5	1285	7.8%
2	126	0.8%
1	23	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16554	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
3	10763	65.0%
4	4357	26.3%
5	1285	7.8%
2	126	0.8%
1	23	0.1%

sqft_lot15
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	7013
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8996.247856

Minimum	659
Maximum	57140
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.5 KiB

Quantile statistics

Minimum	659
5-th percentile	1921.95
Q1	5011.25
median	7500
Q3	9750
95-th percentile	23045.85
Maximum	57140
Range	56481
Interquartile range (IQR)	4738.75

Descriptive statistics

Standard deviation	7636.814694
Coefficient of variation (CV)	0.848888872
Kurtosis	11.84745816
Mean	8996.247856
Median Absolute Deviation (MAD)	2400
Skewness	3.168057171
Sum	148923887
Variance	58320938.67
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	339	2.0%
4000	285	1.7%
6000	230	1.4%
7200	171	1.0%
7500	111	0.7%
4800	108	0.7%
4500	94	0.6%
8400	90	0.5%
3600	89	0.5%
4080	82	0.5%
Other values (7003)	14955	90.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
659	1	< 0.1%
660	1	< 0.1%
748	1	< 0.1%
750	3	< 0.1%
755	1	< 0.1%
758	1	< 0.1%
794	1	< 0.1%
810	2	< 0.1%
886	3	< 0.1%
887	1	< 0.1%

Value	Count	Frequency (%)
57140	1	< 0.1%
57063	2	< 0.1%
57000	1	< 0.1%
56827	1	< 0.1%
56628	6	< 0.1%
56568	1	< 0.1%
56192	2	< 0.1%
55657	1	< 0.1%
55322	1	< 0.1%
55023	1	< 0.1%

sqft_living
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	871
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2016.595143

Minimum	290
Maximum	12050
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.5 KiB

Quantile statistics

Minimum	290
5-th percentile	920
Q1	1400
median	1880
Q3	2478.75
95-th percentile	3560
Maximum	12050
Range	11760
Interquartile range (IQR)	1078.75

Descriptive statistics

Standard deviation	848.7053985
Coefficient of variation (CV)	0.4208605785
Kurtosis	4.451354919
Mean	2016.595143
Median Absolute Deviation (MAD)	520
Skewness	1.323768322
Sum	33382716
Variance	720300.8534
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1440	111	0.7%
1400	110	0.7%
1300	106	0.6%
1540	102	0.6%
1480	102	0.6%
1010	99	0.6%
1660	99	0.6%
1200	99	0.6%
1900	98	0.6%
1560	98	0.6%
Other values (861)	15530	93.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
290	1	< 0.1%
380	1	< 0.1%
390	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
470	2	< 0.1%
480	2	< 0.1%
490	1	< 0.1%
500	1	< 0.1%

Value	Count	Frequency (%)
12050	1	< 0.1%
10040	1	< 0.1%
9200	1	< 0.1%
8020	1	< 0.1%
8010	1	< 0.1%
7710	1	< 0.1%
7620	1	< 0.1%
7480	1	< 0.1%
7390	1	< 0.1%
7350	1	< 0.1%

tiene_sotano
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	937.8 KiB

0	10142
1	6412

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	16554
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	10142	61.3%
1	6412	38.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	10142	61.3%
1	6412	38.7%

Most occurring characters

Value	Count	Frequency (%)
0	10142	61.3%
1	6412	38.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16554	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	10142	61.3%
1	6412	38.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	16554	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	10142	61.3%
1	6412	38.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16554	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	10142	61.3%
1	6412	38.7%

fue_renovada
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	937.8 KiB

0	15905
1	649

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	16554
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	15905	96.1%
1	649	3.9%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	15905	96.1%
1	649	3.9%

Most occurring characters

Value	Count	Frequency (%)
0	15905	96.1%
1	649	3.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16554	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	15905	96.1%
1	649	3.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	16554	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	15905	96.1%
1	649	3.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16554	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	15905	96.1%
1	649	3.9%

yr_date
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1018.6 KiB

2014.0	11227
2015.0	5327

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	99324
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2015.0
2nd row	2015.0
3rd row	2014.0
4th row	2015.0
5th row	2015.0

Common Values

Value	Count	Frequency (%)
2014.0	11227	67.8%
2015.0	5327	32.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
2014.0	11227	67.8%
2015.0	5327	32.2%

Most occurring characters

Value	Count	Frequency (%)
0	33108	33.3%
2	16554	16.7%
1	16554	16.7%
.	16554	16.7%
4	11227	11.3%
5	5327	5.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	82770	83.3%
Other Punctuation	16554	16.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	33108	40.0%
2	16554	20.0%
1	16554	20.0%
4	11227	13.6%
5	5327	6.4%

Other Punctuation

Value	Count	Frequency (%)
.	16554	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	99324	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	33108	33.3%
2	16554	16.7%
1	16554	16.7%
.	16554	16.7%
4	11227	11.3%
5	5327	5.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	99324	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	33108	33.3%
2	16554	16.7%
1	16554	16.7%
.	16554	16.7%
4	11227	11.3%
5	5327	5.4%

antiguedad_venta
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	117
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	43.64552374

Minimum	-1
Maximum	115
Zeros	320
Zeros (%)	1.9%
Negative	12
Negative (%)	0.1%
Memory size	129.5 KiB

Quantile statistics

Minimum	-1
5-th percentile	4
Q1	18
median	40
Q3	63
95-th percentile	99
Maximum	115
Range	116
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	29.34580409
Coefficient of variation (CV)	0.6723668678
Kurtosis	-0.6696125664
Mean	43.64552374
Median Absolute Deviation (MAD)	23
Skewness	0.4480073194
Sum	722508
Variance	861.1762178
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	355	2.1%
11	344	2.1%
8	338	2.0%
10	330	2.0%
0	320	1.9%
37	314	1.9%
7	300	1.8%
36	293	1.8%
46	277	1.7%
47	274	1.7%
Other values (107)	13409	81.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	12	0.1%
0	320	1.9%
1	220	1.3%
2	133	0.8%
3	120	0.7%
4	102	0.6%
5	150	0.9%
6	250	1.5%
7	300	1.8%
8	338	2.0%

Value	Count	Frequency (%)
115	21	0.1%
114	47	0.3%
113	23	0.1%
112	27	0.2%
111	39	0.2%
110	42	0.3%
109	51	0.3%
108	64	0.4%
107	71	0.4%
106	52	0.3%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	zipcode	grade	sqft_basement	view	bathrooms	bedrooms	sqft_above	sqft_living15	lat	floors	yr_renovated	yr_built	long	sqft_lot	price	condition	sqft_lot15	sqft_living	tiene_sotano	yr_date	antiguedad_venta
0	19857	98006	10	NaN	0	2.0	3.0	2610.0	3140.0	47	2.0	NaN	1993.0	-122115	8481.0	810000.0	3	10008.0	2610.0	0	2015.0	22.0
1	14014	98033	8	650.0	1	1.0	3.0	1560.0	2210.0	47	1.0	NaN	1974.0	-122189	8955.0	685000.0	3	8976.0	2210.0	1	2015.0	41.0
2	32909	98005	8	NaN	0	2.0	4.0	2650.0	2230.0	47	2.0	NaN	1986.0	-122154	18295.0	725000.0	3	19856.0	2650.0	0	2014.0	28.0
3	16305	98001	7	900.0	0	1.0	5.0	1050.0	1660.0	47	1.0	NaN	1962.0	-122289	8720.0	274000.0	3	8030.0	1950.0	1	2015.0	53.0
4	6647	98011	7	320.0	0	2.0	3.0	1310.0	1620.0	47	1.0	NaN	1986.0	-122232	6449.0	445000.0	3	7429.0	1630.0	1	2015.0	29.0
5	5865	98040	8	850.0	0	2.0	4.0	1760.0	2550.0	47	1.0	NaN	1978.0	-122229	8760.0	762500.0	4	10376.0	2610.0	1	2014.0	36.0
6	8009	98004	8	NaN	1	1.0	3.0	1700.0	2630.0	47	1.0	NaN	1954.0	-122	14133.0	979000.0	4	17376.0	1700.0	0	2014.0	60.0
7	4731	98011	8	780.0	0	3.0	5.0	2090.0	2640.0	47	2.0	NaN	2007.0	-122192	4369.0	540000.0	3	4610.0	2870.0	1	2014.0	7.0
8	38480	98052	9	NaN	0	2.0	4.0	2700.0	2730.0	47	2.0	NaN	2004.0	-122116	8810.0	690000.0	3	5100.0	2700.0	0	2014.0	10.0
9	13246	98072	7	530.0	0	1.0	3.0	1130.0	1260.0	47	1.0	NaN	1976.0	-122162	9673.0	375000.0	3	9681.0	1660.0	1	2014.0	38.0

Last rows

	df_index	zipcode	grade	sqft_basement	view	bathrooms	bedrooms	sqft_above	sqft_living15	lat	floors	yr_renovated	yr_built	long	sqft_lot	price	condition	sqft_lot15	sqft_living	tiene_sotano	yr_date	antiguedad_venta
16544	9302	98148	7	NaN	0	1.0	2.0	940.0	1890.0	47	1.0	NaN	1954.0	-122329	6000.0	246500.0	2	8547.0	940.0	0	2015.0	61.0
16545	26872	98008	6	NaN	0	1.0	3.0	1270.0	1210.0	47	1.0	NaN	1959.0	-122118	8000.0	475000.0	4	7875.0	1270.0	0	2014.0	55.0
16546	49558	98198	6	NaN	2	1.0	2.0	1170.0	1380.0	47	1.0	NaN	1911.0	-122321	8925.0	175000.0	3	7440.0	1170.0	0	2014.0	103.0
16547	146	98117	6	120.0	0	1.0	2.0	860.0	980.0	47	1.0	NaN	1918.0	-122366	2130.0	400000.0	4	2800.0	980.0	1	2014.0	96.0
16548	9396	98065	7	NaN	0	2.0	3.0	1950.0	2190.0	47	2.0	NaN	2007.0	-121869	7263.0	409000.0	3	5900.0	1950.0	0	2014.0	7.0
16549	14466	98198	7	NaN	0	2.0	4.0	1780.0	1630.0	47	2.0	NaN	1991.0	-122302	6000.0	175000.0	3	6000.0	1780.0	0	2014.0	23.0
16550	30056	98042	6	NaN	0	1.0	3.0	840.0	920.0	47	1.0	NaN	1969.0	-122085	5525.0	191000.0	5	5330.0	840.0	0	2015.0	46.0
16551	5824	98106	7	550.0	0	2.0	3.0	1230.0	1780.0	47	1.0	NaN	1990.0	-122353	6771.0	310000.0	3	6771.0	1780.0	1	2014.0	24.0
16552	16712	98038	7	NaN	0	2.0	3.0	1340.0	1060.0	47	2.0	NaN	1995.0	-122038	3011.0	230000.0	3	3232.0	1340.0	0	2014.0	19.0
16553	237	98075	10	NaN	0	2.0	3.0	3240.0	2970.0	47	2.0	NaN	1994.0	-122038	7857.0	800000.0	3	7857.0	3240.0	0	2014.0	20.0

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common